GoldenGate Bridges the gaps between Production and BCP
Oracle GoldenGate is used as part of our business continuity plan. We use it to replicate in near realtime, transactions from the primary …
Starting at $250 Per License
View PricingOverview
What is Oracle GoldenGate?
Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Pricing
Data Integration
$250.00
Cloud
Per License
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://cloud.oracle.com/en_US/goldenga…
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Demos
Oracle Goldengate demo
YouTube
Webinar On Oracle Goldengate Different Types of Architecture and Installation of Goldengate_31st May
YouTube
2017 05 19 22 04 Oracle Goldengate Demo
YouTube
Webinar On Oracle Goldengate Different Types of Architecture and Installation of Goldengate_14 June
YouTube
Oracle 12c Golgen Gate Essentials Training - DEMO
YouTube
Configuring Integrated Extract and Integrated Replicat Using Oracle GoldenGate 12c on Linux
YouTube
Product Details
- About
- Integrations
- Competitors
- Tech Details
- Downloadables
- FAQs
What is Oracle GoldenGate?
Oracle GoldenGate products offer real-time data integration, transactional data replication, and data comparison across heterogeneous systems. Oracle GoldenGate enables:
-Real-time business intelligence and stream analytics for improved business insight
-Query offloading to maximize OLTP performance
-Zero-downtime data migration, disaster recovery, and active-active database synchronization for continuous availability
Datasheet - https://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-ds-2030490.pdf
Datasheet (Stream Analytics) https://www.oracle.com/us/products/middleware/data-integration/oracle-stream-analytics-ds-4478221.pd...
Analyst whitepaper https://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-ds-2030490.pdf
Documentation
Video Oracle GoldenGate Cloud Service - Get an overview of this cloud based real-time data integration and replication service that provides quick, easy, accurate and safe data movement to the cloud. https://youtu.be/liBgUwHgVew
Oracle GoldenGate Video
GoldenGate Cloud for real-time replication
Oracle GoldenGate Integrations
Oracle GoldenGate Competitors
Oracle GoldenGate Technical Details
| Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Unspecified |
| Mobile Application | No |
Oracle GoldenGate Downloadables
Frequently Asked Questions
Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.
Azure Data Factory, AWS Database Migration Service, and Informatica Cloud Data Integration are common alternatives for Oracle GoldenGate.
Reviewers rate Oracle Implementation Satisfaction highest, with a score of 9.7.
The most common users of Oracle GoldenGate are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(221)Attribute Ratings
Reviews
(1-25 of 28)Companies can't remove reviews or game the system. Here's why
December 13, 2020
GoldenGate - Ideal Synchronization for Low/Moderate Data Complexity
<p>GoldenGate (GG) is being used by the utility company I work
for in various areas. </p>
<p>Data Analytics is the main use of GG at the moment. Normally, the sheer level of database hits
required by our daily Business Intelligence reports would place a heavy burden on
the disk groups in our core ASM; however, with GG, we are able to seamlessly
replicate that data in real-time into a separate database using separate
resources. By doing this, we are able to
alleviate potential bandwidth issues posed by our BI group’s database querying. It should be noted that GG does not require
all tables to be replicated: we only replicate under 100 of the thousands of
tables in the main databases. Our GG
database is not normalized, so we are essentially combining disparate databases
into one, which has its advantages and disadvantages.</p>
<p>Another use we currently have for GoldenGate is on a
large project level. As part of a data
conversion effort, we are using GoldenGate to replicate data into a separate
database in real-time. This will allow
us to save 12+ hours during our conversion, as well will not need to execute an
RMAN backup in order to move data into our target database. In other words, we are directly replicating
data into our target database, so right when we are ready to switch
servers/databases for the go-live of our project, we will be ready to
immediately start to convert data.</p>
- Replicates data without "missing" items. This is key, as there was initial concern that with the amount of tables and columns involved, certain items were bound to be "missed", though we have not seen this (outside of an anomalous server crash incident that wasn't due to GG).
- Replicates data in real-time. Proof of concept for GG was intuitive for end users, as the data is immediately available. There are no "jobs" or "interfaces" that need to be run: the data is immediately available on the target database for viewing
- GG is able to modify data "in transit", which can save loads of time if you were to need to instead modify large amounts of data after it is synchronized to the target database. As one would expect, this is seamless with low complexity modification, by can become untenable with larger blocks of data (e.g. CLOBs).
- GG can sometimes lag behind in synching large objects (i.e. CLOBs and BLOBs) on tables, which is odd because we are using GG on an Oracle database with an Oracle software suite. It's definitely possible to use GG on non-LOB columns, and we do, but it is best used for non-LOB columns, just based on personal experience.
- When using GG, it is key to separate the replicat groups into manageable sizes. This can be somewhat burdensome, as maintenance will increase with each new replicat group. If tables are large enough, they need to essentially be their own group.
- Sometimes, replicat groups need to be grouped by parent and child (if using in a normalized db). This again increases maintenance due to more groups existing. This will be especially true for large tables that are partitioned with foreign key constraints on child tables.
December 08, 2020
OGG - always in-sync
Our company in EMEA region has two data centers, working in the Active/Passive(standing by) mode. We use Oracle GoldenGate to "clone" the live data transactions from the master database (which resides in the currently active data center) to the standing-by database (which is in the limited read-only mode, and resides in our passive data center). If the active DC is down and DR is required, the standing-by database in the passive DC will be promoted to the master one which can take R/W transactions, and the OGG will reverse the uni-direction data copy. This pattern is applied on all business critical IT application's DB instances.
- As the product under the Oracle umbrella, it perfectly and natively supports the Oracle database very well.
- For the standard scenario and use cases, the configuration is straight-forward (in our case uni-direction copy from source to target).
- It is robust and the performance meets our SLA, even for a large amount of data volume.
- The error report is not only detailed but hits the right points, so trouble shooting is easy.
- The metrics UI is another product that should be purchased separately, with high price, we use open source Grafana as a replacement.
- Documentation can be improved. Sometimes [it is] not so easy to find the correct information quickly.
December 07, 2020
Replicate as much as you can as frequent as you can
Currently [Oracle] GoldenGate is being used to replicate a backup database for disaster recovery and also integrating different data sources to a single database.
- Documentation is easy to follow
- Downtime seems very minimal
- Able replicate in real-time
- Expensive, considering we were going to use Active Data Guard.
- A lot of memory is being used.
- No UI
December 05, 2020
Oracle Golden Gate is efficient and high performance
Oracle GoldenGate is being used by the departments as required and as needed. Especially we used for migration purpose. We are migrating the databases from on-premises to Cloud. The real problem is to complete the migration with zero-downtime. We need a revert plan (rollback strategy) when it fails. [Oracle] GoldenGate helped a lot in completing this migration task with Zero-downtime. [Oracle GoldenGate] is real-time data capture, continuous delivery of transaction data across different sources.
- OGG can be used and integrated with heterogeneous databases as well as homogeneous databases.
- OGG is easy setup as well as easy learning curve
- OGG supports large databases
- OGG support many uses cases (topologies) such as unidirectional replication, bidirectional, peer-to-peer, Broadcast, Cascading replication etc.
- OGG can be used not only for CDC (change capture), can be used to full load
- Expensive
- Require resources such as OGG script developer and SME
December 04, 2020
Oracle GoldenGate Review
We implemented Oracle GoldenGate on at least 400 database environments. We have a large infrastructure with tons of applications to assign installation and repair jobs to field technicians. In some of the applications, we can't afford latency or replication errors. GoldenGate has been a great tool.
- I was able to find what I needed, but it took longer than I think it needed to. The system was navigable, but not until I had training on it. Before that I was clueless on how to find anything.
- It allows the replication in real time from the Oracle database in RAC to the contingency database, through the immediate replication of the data in the redo logs, without the need to wait for them to be written at the level of the archive logs.
- You can have multiple different data sources coming into this Oracle GoldenGate. You are not limited to only Oracle databases.
- The time that it takes to implement Oracle GoldenGate. Because you can have multiple databases going through it it can take a long time to set it up.
- It was more complicated than it needed to be. Without the training I feel that it isn't intuitive. I think maybe the structure should be reinvented so that it is more intuitive.
- GoldenGate replication is only for databases, it would be nice to use it across file and folders
Oracle GoldenGate is used in a traditional manner for homogeneous data replication between production and non-production environments. This allows the different environments to be utilized for different purposes with the same source data. Some environments are for real-time data analysis while others are backend reporting and analysis.
Oracle GoldenGate allows us to split highly responsive, mission critical systems from lower environments while retaining clean copies of source data.
Oracle GoldenGate allows us to split highly responsive, mission critical systems from lower environments while retaining clean copies of source data.
- Integrates with Oracle databases and Oracle database servers (particularly exadata - engineered systems)
- Easy to define source and destination data attributes and configuration
- Robust error reporting
- More integration with traditional Oracle products such as SQL*plus
- GUI
- More transparent integration with OEM
- More standard error reporting similar to traditional Oracle products
December 04, 2019
GoldenGate is best for real-time data needs.
It's used by our Computer Services Department to create reporting databases as well as for DR. The replication is unidirectional and replicates data in four non-production environments. This enables us to perform long-running queries without affecting the performance of our production systems. We have a lot of clients using it. It can migrate data between databases in realtime.
- Flexibility to migrate data.
- Fast transactions between source and target databases .
- Easy to analyze problems when occur.
- Good for disaster recovery and data protection database.
- Oracle GoldenGate Studio is expensive, and you can use Grafana instead.
- Character set problems when migrating database.
October 07, 2019
The Golden Gate to Success!
Oracle GoldenGate is being used by our core software development team. We are using it as a real-time data replication solution to achieve high availability/disaster recovery for our data, to prepare a read-replica database to offload query-based requests, and to perform real-time business intelligence related operations on our synced data.
- No Downtime during System Migration. Replicating data onto other servers in preparation for a system migration does not result in any downtime.
- Initial setup of Oracle GoldenGate is easy and straightforward. Instructions are precise and simple to follow.
- Thorough and Insightful Documentation. All troubleshooting and tuning issues are well-known by the community, and hence are well-documented online.
- Lack of Simple UI for Non-Technical Users. It would be nice to have an option to toggle simpler, and less advanced options to make it easier for non-technical users to understand what Oracle GoldenGate is.
- Lack of Variety of Performance Metrics. Would prefer more detailed performance metrics to be offered out-of-the-box.
- Some Features Won't Always Run as Expected. We have sometimes faced issues when features don't run as they are used to. They will be working at times, but there is the occasional failure in streaming.
September 17, 2019
Oracle GoldenGate Review
GoldenGate is being used as a DR solution and as well as a method for replicating from a transactional to reporting DB. It is used across the whole organization. It addresses a need for disaster recovery on different data centers including the cloud.
- Replication of data.
- Easy of set up.
- Notification of status.
- Improvement of collision management.
- Log dump features could be improved for better ease of use.
September 17, 2019
GoldenGate for active applications across datacenters
We use Oracle GoldenGate for multiple reasons such as data replication, to maintain active/active databases for critical applications and not but least for database migration with zero downtime. We're happy with the usage and its purposes. It is being used across the whole organization. We use OEM monitoring to alert the monitoring team when there is a lag on the DB sync.
- Data replication to keep our data up-to-date and used for reporting purposes.
- Data migration with zero downtime.
- Data sync between two data centers to keep the system active/active with load balancing.
- We're facing issues during bi-directional replication. The detailed data quality issues alerts may be helpful.
September 17, 2019
Oracle GoldenGate - The best logical replication tool in the market.
Oracle GoldenGate is used widely across the organization. We use it for heterogeneous replication, active-active and active hot standby, and offloading reporting.
- Oracle's new AutoCDR (conflict detection and resolution) feature makes setting up active-active replication fairly easy. We were able to setup active-active replication using the AutoCDR feature in a very short time.
- We had plans for separating reporting and ingestion from our primary DW system. This system generates an excess of 1TB of redo during ingestion. GoldenGates coordinated replicate helped us achieve this almost impossible task with ease.
- In my previous workplace, for a large telecom company, we had to publish data from the store of records as a service. We used GoldenGate BigData adapters to replicate data to a Kafka endpoint.
- For quick application failovers, we use GoldenGate Active-Passive replication with connection failover defined in the WebLogic connection settings.
- There are certain challenges using the product when the redo generation is in excess of about 120G per hour.
- For large transaction (more than 10 million records per commit), extract get slower. Some other replication tools do such activities better.
- Ability to recreate large transaction without breaking the transaction into individual statements may help. There are ways to make this transaction faster, but having the ability to replicate a statement as it was issued on the source may be helpful in some cases.
September 17, 2019
GoldenGate Rocks
We use it to move data between databases to a dw for reporting purposes. We also use it to transform data as it moves, and we use it to populate pdb's to enable our services architecture.
- GoldenGate, using CDC, moves data between databases and database technologies to enable near real-time propagation.
- GoldenGate can transform data as it moves from tables in the same or different databases.
- GoldenGate can move data between database platforms.
- We need more rapid support for bug mitigation.
- GoldenGate's API needs to allow for streaming from Oracle's cloud databases where we don't have access to the OS.
September 16, 2019
The best replication tool on the market
We use GoldenGate to replicate some of the data from the production database to a data warehouse. It is used by the IT department. By using GoldenGate we don't impact the production database. We can run queries or reports or any long queries from the replicated database using GoldenGate. At one time we even used GoldenGate as a DR database and replicated entire production database. By doing so, one time when we had an outage and lost the production database, this DR became available to us and switched it to the primary. So we have a lot of advantages when using GoldenGate. We can replicate some tables or all tables and different scenarios of replicating data using functions and triggers. The business problem it addressed was less impact on production databases, more realtime data available to the business without putting an overload on production databases.
- Realtime replication and zero data loss.
- Less lag and more reliable.
- No downtime for our primary database.
- GUI could use a little improvement.
September 16, 2019
Sr. Database Engineer
We have multiple data centers and all of them share the same copy of DB. We use GoldenGate to do cross datacenters replication for Oracle and My SQL DBs as an HA solution. As our DBs are one of the busiest in the world and have a very tight SLA for replication lag which we can achieve by GoldenGate. We have explored few other products like SharePlex but GG done the work for us. GoldenGate is a de-facto standard for replication in our organization.
- GoldenGate is tightly integrated with Oracle databases and supports all features like encryption, LOBs, compressions etc.
- GoldenGate is very flexible, you can customize it as per your requirement. Whether it is high transaction DB or a DR site, it can work anywhere.
- We can dump data in multiple formats with big data adaptor like kafka, hdfs, xml etc.
- We can achieve high throughput by splitting extracts and replicats. Also from integrated capture and replication it is so smart that it spawn parallel process based on the load.
- Goldengate is very useful in cross platform migration.
- Memory consumption of extract is exponentially high, sometimes extract restart consumes so much memory that it impact the current application connections.
- There are so many bugs in the system for dumping data via xml or other format like hdfs. Data corruption is so frequent that we wrote our own scripts to detect and repair xml corruption. As always we didn't get proper support from Oracle on this issue.
- For active-active replication on busy systems, online DDL change can sometimes cause data discrepancy.
- With integrated capture creating index on big table is a headache even thought you are creating with via gg user. Extract starts get lagging even after skipping the DDL by gg user in param file. This was not the case with classic capture.
September 16, 2019
GoldenGate for building data pipelines
We have built a data change pipeline using GG technology by plugging in Kafka in front. Also, it's helped us in fault tolerance as a live DR database is readily available in a separate DC in case current DC goes down. In both modes, it's been super helpful to ensure data is sent in an async manner to reporting systems. It's saved us in cases of DC failures.
- Data replication in real-time.
- Fault tolerance.
- No data loss.
- Better documentation would be appreciated.
We have been using Oracle GoldenGate (OGG) for our replication needs. We have a mix of database environments including Oracle, DB2 and Microsoft SQL Server. We use Oracle GoldenGate to replicate across the mix of these different RDBMS. OGG is reliable, fast, has high throughput and allows heterogeneous replication.
We also use OGG Management Pack which is an extra license cost and includes Oracle GoldenGate Monitor, Oracle GoldenGate Director and Oracle GoldenGate Veridata.
We also use OGG Management Pack which is an extra license cost and includes Oracle GoldenGate Monitor, Oracle GoldenGate Director and Oracle GoldenGate Veridata.
- Supports both homogeneous and heterogeneous replications.
- Supports DDL replication if both source and target databases are Oracle.
- Supports multiple replication topology such as unidirectional, bi-directional, cascading, peer to peer and multicasting.
- Can interface with JMS and Big Data Systems.
- Like most Oracle products, it is quite expensive.
- Too many tables in single replication channels creates performance bottlenecks. You have to split your tables into multiple channels.
December 21, 2018
Oracle GoldenGate: Continuous and Real-time data movement
Oracle GoldenGate is used by organization, which provides high availability and real-time data integration solutions. To be specific, the company needs a platform that allows business applications to benefit from continuous access to real-time information in a diverse IT environment without compromising performance.
- It provides continuous capture and delivery of data from source to target due to its real-time data feed feature.
- It maintains the reliability and accuracy of transactional data.
- It is very easy to install.
- Complete data recovery is possible in case of failures.
- The product is somewhat expensive to most of the companies.
November 12, 2018
Overall, GoldenGate is an excellent software to provide real-time data integration and replication
It is used by IT to sync data across databases. The source is our SQL Server database and the target is the Oracle database. The source database is outsourced to a third party and we use GoldenGate to sync the data to our local Oracle database. The main challenge we have is that GoldenGate can't replicate DDL among different RDBMS. We have had to stop and rebuild GoldenGate multiple times due to DDL change on the source side.
- Real Time Sync
- Less overhead
- Stable performance
- Should make the high availability easier to use. Not bound to only DBFS or ACFS.
- Need a powerful GUI tool to make the configuration easier.
- Could it be cheaper? Or have a basic free version?
- If it could support DDL among different RDBMS, that would be great.
November 09, 2018
GoldenGate with 99.999 uptime
We use Oracle GoldenGate to achieve high availability, perform upgrades, and for patching and data center drills.
We use Golden Gate in active active configuration.
It meets our SLA requirement of 99999.
- Oracle GoldenGate provides the best HA solution. It gives us 99.999% availability in a year.
- GoldenGate is very easy to install, set up and troubleshoot. The commands are fairly simple.
- GoldenGate is a very lightweight tool. It performs auto CDR in active setups.
- Tuning Golden Gate is fairly very simple.
- Golden Gate is very fast in catching up the lag.
- Where there are open transactions GoldenGate needs to auto-detect them.
- GoldenGate should have dba views like Oracle Database.
- Patching or upgrading GoldenGate is a bit complicated.
- When extract or pump trail file sequence number is about to reach the max limit, we should get a warning or critical threshold alert.
- When Integrated replicat is altered, it converts to classic replicat. We don't get any message that the replicat is running in classic mode. There should be some sort of alerting in the ggserrlog file.
November 07, 2018
MyCentsonGold
We are using this application to replicate data from one data center to other data center. And it's very accurate and it's solved our data issues during the down time the replication helped not loosing of business and with little impact to customer for check out and creating profiles
- Well organized and greater data integration
- Response Time(no latency) able to sustain the load during the process
- Because of Golden Gate our business able to deliver the continuance and high availability of the application
- Less hassles of maintenance
- Little more flexibility and should be more robustness
- Need improvement on session management
- Replication takes more time - you need a better approach with less time
November 06, 2018
Oracle GoldenGate is a good product.
We use Oracle GoldenGate as a part of our high availability solution. The entire database is replicated in real time to other geographical facilities and makes the system available for 24/7.
- GoldenGate is good for real-time data replication.
- The database upgrade and migration was possible with zero downtime because of having GoldenGate in place.
- It also works with different databases other than Oracle
- The monitoring side could be improved with easy to use reporting.
September 07, 2018
Undoubtedly the best database replication solution in market
Score 10 out of 10
Vetted Review
Verified User
I have been using Oracle GoldenGate since 2011, 2 years right after Oracle acquired the company. It was an awesome project back then with version 10, but Oracle has continued adding tonnes of features to it ever since and this is just the best replication solution I have worked with. I have done all kinds of replication using Oracle GoldenGate. Be it homogeneous, heterogeneous, unidirectional, bidirectional, on premise, on cloud (Oracle Public Cloud), integrating with JMS (Java Messaging System) - we have done it all. We have loved the product so much that we have over years replaced all our existing replication infrastructure using Oracle GoldenGate. I love that you can perform changes in almost zero downtime, replicate millions of data in sub seconds and their is large online documentations and forums to help you with troubleshooting any problems. This doesn't requires a lot of expertise to begin with and overtime, you will love working on it. Oracle GoldenGate now also comes with many GUI based tools like OGG Studio, OGG Director, OGG Monitor and OGG Veridata. These come with additional cost, but are great add-ons. We implemented Oracle GoldenGate on at least 400 database environments. We have a large infrastructure with tonnes of applications to assign installation and repair jobs to field technicians. In some of the applications, we can't afford latency or replication errors. GoldenGate has been a great tool.
- Oracle GoldenGate lets you replicate data in homogeneous, heterogeneous, unidirectional, bidirectional, on premise , on cloud (Oracle Public Cloud).
- You can integrate Oracle GoldenGate with non relational database systems like JMS (Java Messaging System).
- You can also generate flat files in real time and feed into systems like a data lake.
- I am an Oracle GoldenGate fan, so it's hard to say what I dislike about it. But yes, I would have loved if it was easier to find syntax errors in your GoldenGate commands. Sometimes it just tells you ambiguous generic error messages for a syntax error.
- Oracle GoldenGate sometimes gives you too many ways to do the same thing. It makes it slightly confusing for less experienced people to choose among different options available.
- logdump utility is great to view a trail file being replicated, but it is not straight forward and easy to understand. It requires a lot of technical knowledge to read through a trail file using log dump utility. This can be made better.
October 30, 2017
Different Source Systems (IBM DB2, Microsoft SQL Server) Are Supported For Real Time Replication.
Replicated source system data seamlessly flew in our Operational Data Store (ODS). Different types of source systems (IBM DB2, Microsoft SQL Server) are supported for real time replication. With the upgrade, I now am able to replicate Big Data solution from any supported source system to Hadoop clusters.
- Ease of installation
- Ease of maintenance
- Powerful output with sub-second speed
- Supporting Big Data and Cloud environment
- Capturing source data based on transnational log, no cost on source CPU
- Handle the distribution and the delivery of committed data in real-time
- Supports heterogeneous systems regarding target or source database
- Can be implemented uni-directional, bi-directional or peer-to-peer mode
- Zero downtime migration
- Supports data distribution
- Can be used for disaster recovery or data protection
- Oracle GoldenGate Studio could be more user-friendly.
- It would be better for Oracle Golden Gate Studio GUI to include other OGG related licensed products (i.e. Veridata or others).
October 25, 2017
Oracle GoldenGate for real time replication
We use Oracle databases as the primary data storage facility for our university. We have many ERP products that need to integrate with custom applications designed to support our IT infrastructure. We decided to use Oracle GoldenGate as a means of keeping data in sync between our ERP system and a temporary data-cache. It offers real-time replication of data between different database systems.
- I think it's a very useful tool that can provide live transactional data across heterogeneous environments.
- Oracle GoldenGate allows you to configure data mapping between different tables using simple configuration files.
- The licensing agreement that we had for GoldenGate did not include an admin visual console to monitor the different replication processes in real time.
- Once a replication process gets abended due to some data load error, the product does not skip onto the next record to continue replication. This was one feature we really needed.
August 11, 2017
Golden gate use case for disaster recovery
We have been successfully using Goldengate to sync our prod and disaster recovery environments for over a year. It decreased the time to sync and increased reliability. We are very happy with it.
- Disaster recovery sync, faster than other products like SharePlex.
- Integration features, we are looking at using it to sync other DBs and move data around.
- Future use case is to offload data to Cassandra.
- Ability to help migrate between different versions of Oracle could be improved.
- Possible compression of data to help with transfers across data centers.
- Cost is a little high.